﻿CREATE TABLE [flcr].[SERVICE_PROPERTY] (
    [SERVICE_PROP_ID]     INT           IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]          VARCHAR (50)  NOT NULL,
    [AUDIT_DTTM]          DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]       INT           NOT NULL,
    [AUDIT_MOD_USER]      VARCHAR (50)  NOT NULL,
    [AUDIT_MOD_DTTM]      DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]   INT           NOT NULL,
    [BUILTIN]             BIT           NOT NULL,
    [ACTIVE_FLG]          BIT           NOT NULL,
    [SORT_ORDER]          INT           NOT NULL,
    [SERVICE_ID]          INT           NOT NULL,
    [SERVICE_PROP_TYPE]   INT           NOT NULL,
    [SERVICE_PROP_IVALUE] VARCHAR (MAX) NOT NULL,
    [PARENT_ID]           INT           NULL
);

